Toward Reverse Engineering of VBA Based Excel Spreadsheet Applications
نویسندگان
چکیده
Modern spreadsheet systems can be used to implement complex spreadsheet applications including data sheets, customized user forms and executable procedures written in a scripting language. These applications are often developed by practitioners that do not follow any software engineering practice and do not produce any design documentation. Thus, spreadsheet applications may be very difficult to be maintained or restructured. In this position paper we present in a nutshell two reverse engineering techniques and a tool that we are currently realizing for the abstraction of conceptual data models and business logic models.
منابع مشابه
Ac 2007-1478: Introducing Civil Engineering Analysis through Programming
This paper describes a course in computer programming that is being offered to freshmen and sophomores in civil engineering at NC State. Visual Basic (VBA in Excel) and MATLAB are being used as the programming languages. Much of the learning occurs through reverse engineering and imitation. Typical civil engineering problems are used to present the programming concepts. Especially in the instan...
متن کاملUsing Spreadsheets and VBA for Teaching Civil Engineering Concepts
Spreadsheets are becoming increasingly popular in solving engineering related problems. Among the strong features of spreadsheets are their instinctive cell-based structure and easy to use capabilities. Excel, for example, is a powerful spreadsheet with VBA robust programming capabilities that can be a powerful tool for teaching civil engineering concepts. Spreadsheets can do basic calculations...
متن کاملUser Defined Spreadsheet Functions in Excel
Creating user defined functions (UDFs) is a powerful method to improve the quality of computer applications, in particular spreadsheets. However, the only direct way to use UDFs in spreadsheets is to switch from the functional and declarative style of spreadsheet formulas to the imperative VBA, which creates a high entry barrier even for proficient spreadsheet users. It has been proposed to ext...
متن کاملAssessing Excel VBA Suitability for Monte Carlo Simulation
Monte Carlo (MC) simulation includes a wide range of stochastic techniques used to quantitatively evaluate the behavior of complex systems or processes. Microsoft Excel spreadsheets with Visual Basic for Applications (VBA) software is, arguably, the most commonly employed general purpose tool for MC simulation. Despite the popularity of the Excel in many industries and educational institutions,...
متن کاملEmbedding R in Windows applications, and executing R remotely
R is object oriented, and objects are the standard way of packing analysis results in R. Many programming environments and applications programs in Windows can act as as (D)COM clients, which is the standard way of accessing objects exposed by (D)COM servers. Particularly, all Microsoft office programs are (D)COM clients and therefore can access any (D)COM server. Therefore, in encapsulating R ...
متن کاملذخیره در منابع من
با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید
عنوان ژورنال:
دوره شماره
صفحات -
تاریخ انتشار 2015